www.gusucode.com > VC++ 酒店管理系统-源码程序 > VC++ 酒店管理系统-源码程序/code/hotel2003/InfoSet.cpp
//Download by http://www.NewXing.com // InfoSet.cpp : implementation file // #include "stdafx.h" #include "qq.h" #include "InfoSet.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CGuestInfoSet IMPLEMENT_DYNAMIC(CGuestInfoSet, CRecordset) CGuestInfoSet::CGuestInfoSet(CDatabase* pdb) : CRecordset(pdb) { //{{AFX_FIELD_INIT(CGuestInfoSet) m_HandCode = _T(""); m_Name = _T(""); m_GuestType = _T(""); m_Sex = _T(""); m_Certificate = _T(""); m_CertifyCode = _T(""); // m_StartTime=_T(""); m_IsMember = FALSE; m_IsMaster = FALSE; m_GroupID = _T(""); m_GuestNum = 0; m_RoomNum = _T(""); m_RoomCode = _T(""); m_nFields = 12; //}}AFX_FIELD_INIT m_nDefaultType = snapshot; } CString CGuestInfoSet::GetDefaultConnect() { return _T("ODBC;DSN=酒店管理系统"); } CString CGuestInfoSet::GetDefaultSQL() { return _T("[GuestInfo]"); } void CGuestInfoSet::DoFieldExchange(CFieldExchange* pFX) { //{{AFX_FIELD_MAP(CGuestInfoSet) pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Text(pFX, _T("[HandCode]"), m_HandCode); RFX_Text(pFX, _T("[Name]"), m_Name); RFX_Text(pFX, _T("[GuestType]"), m_GuestType); RFX_Text(pFX, _T("[Sex]"), m_Sex); RFX_Text(pFX, _T("[Certificate]"), m_Certificate); RFX_Text(pFX, _T("[CertifyCode]"), m_CertifyCode); RFX_Bool(pFX, _T("[IsMember]"), m_IsMember); RFX_Bool(pFX, _T("[IsMaster]"), m_IsMaster); RFX_Text(pFX, _T("[GroupID]"), m_GroupID); RFX_Long(pFX, _T("[GuestNum]"), m_GuestNum); RFX_Text(pFX, _T("[RoomNum]"), m_RoomNum); RFX_Text(pFX, _T("[RoomCode]"), m_RoomCode); // RFX_Text(pFX, _T("[StartTime]"),m_StartTime); //}}AFX_FIELD_MAP } ///////////////////////////////////////////////////////////////////////////// // CGuestInfoSet diagnostics #ifdef _DEBUG void CGuestInfoSet::AssertValid() const { CRecordset::AssertValid(); } void CGuestInfoSet::Dump(CDumpContext& dc) const { CRecordset::Dump(dc); } #endif //_DEBUG ///////////////////////////////////////////////////////////////////////////// // CRoomInfoSet IMPLEMENT_DYNAMIC(CRoomInfoSet, CRecordset) CRoomInfoSet::CRoomInfoSet(CDatabase* pdb) : CRecordset(pdb) { //{{AFX_FIELD_INIT(CRoomInfoSet) m_RoomCode = _T(""); m_RoomType = _T(""); m_Floor = 0; m_Phone = _T(""); m_RoomStatus = _T(""); m_PriceType = FALSE; m_Price = 0.0f; m_nFields = 7; //}}AFX_FIELD_INIT m_nDefaultType = snapshot; } CString CRoomInfoSet::GetDefaultConnect() { return _T("ODBC;DSN=酒店管理系统"); } CString CRoomInfoSet::GetDefaultSQL() { return _T("[RoomInfo]"); } void CRoomInfoSet::DoFieldExchange(CFieldExchange* pFX) { //{{AFX_FIELD_MAP(CRoomInfoSet) pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Text(pFX, _T("[RoomCode]"), m_RoomCode); RFX_Text(pFX, _T("[RoomType]"), m_RoomType); RFX_Int(pFX, _T("[Floor]"), m_Floor); RFX_Text(pFX, _T("[Phone]"), m_Phone); RFX_Text(pFX, _T("[RoomStatus]"), m_RoomStatus); RFX_Bool(pFX, _T("[PriceType]"), m_PriceType); RFX_Single(pFX, _T("[Price]"), m_Price); //}}AFX_FIELD_MAP } ///////////////////////////////////////////////////////////////////////////// // CRoomInfoSet diagnostics #ifdef _DEBUG void CRoomInfoSet::AssertValid() const { CRecordset::AssertValid(); } void CRoomInfoSet::Dump(CDumpContext& dc) const { CRecordset::Dump(dc); } #endif //_DEBUG ////////////////////////////////////////////////////////////////////// // CCreateBillCode Class ////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////// // Construction/Destruction ////////////////////////////////////////////////////////////////////// //int CCreateBillCode::m_BillNum=0; CCreateBillCode::CCreateBillCode() { // m_BillNum++; } CCreateBillCode::~CCreateBillCode() { } CString CCreateBillCode::GenereBillCode() {//产生帐单号码 long n=0; CBillInfoSet m_BillInfoSet; if(!m_BillInfoSet.Open()) { AfxMessageBox("打开数据库失败!"); return CString(""); } // long n=m_BillInfoSet.GetRecordCount(); //不要调用GetRecordCount()函数会得到错误的结果 m_BillInfoSet.MoveFirst();//移动到第一条记录 while (!m_BillInfoSet.IsEOF()) { n++; m_BillInfoSet.MoveNext();//移动到下一条记录 } m_BillInfoSet.Close(); //关闭数据库 CTime time=CTime::GetCurrentTime(); CString str=time.Format("%H%M"); CString strBillCode; strBillCode.Format("%ld",n+1); strBillCode="B"+str+strBillCode; return strBillCode; } CString CCreateBillCode::GenereBillCodeForCheckOut() {//为结帐帐单产生帐单号码 //产生帐单号码 long n=0; CBillCheckoutInfoSet m_BillCheckoutInfoSet; if(!m_BillCheckoutInfoSet.Open()) { AfxMessageBox("打开数据库失败!"); return CString(""); } // long n=m_BillInfoSet.GetRecordCount(); //不要调用GetRecordCount()函数会得到错误的结果 m_BillCheckoutInfoSet.MoveFirst();//移动到第一条记录 while (!m_BillCheckoutInfoSet.IsEOF()) { n++; m_BillCheckoutInfoSet.MoveNext();//移动到下一条记录 } m_BillCheckoutInfoSet.Close(); //关闭数据库 CTime time=CTime::GetCurrentTime(); CString str=time.Format("%H%M%S"); CString strBillCode; strBillCode.Format("%ld",n+1); strBillCode="B"+str+strBillCode; return strBillCode; } ////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////// // CBillInfoSet IMPLEMENT_DYNAMIC(CBillInfoSet, CRecordset) CBillInfoSet::CBillInfoSet(CDatabase* pdb) : CRecordset(pdb) { //{{AFX_FIELD_INIT(CBillInfoSet) m_BillCode = _T(""); m_HandCode = _T(""); m_Sum = 0; m_Paid = 0; m_Rebate = _T(""); m_Striked = FALSE; m_nFields = 6; //}}AFX_FIELD_INIT m_nDefaultType = snapshot; } CString CBillInfoSet::GetDefaultConnect() { return _T("ODBC;DSN=酒店管理系统"); } CString CBillInfoSet::GetDefaultSQL() { return _T("[BillInfo]"); } void CBillInfoSet::DoFieldExchange(CFieldExchange* pFX) { //{{AFX_FIELD_MAP(CBillInfoSet) pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Text(pFX, _T("[BillCode]"), m_BillCode); RFX_Text(pFX, _T("[HandCode]"), m_HandCode); RFX_Long(pFX, _T("[Sum]"), m_Sum); RFX_Long(pFX, _T("[Paid]"), m_Paid); RFX_Text(pFX, _T("[Rebate]"), m_Rebate); RFX_Bool(pFX, _T("[Striked]"), m_Striked); //}}AFX_FIELD_MAP } ///////////////////////////////////////////////////////////////////////////// // CBillInfoSet diagnostics #ifdef _DEBUG void CBillInfoSet::AssertValid() const { CRecordset::AssertValid(); } void CBillInfoSet::Dump(CDumpContext& dc) const { CRecordset::Dump(dc); } #endif //_DEBUG ///////////////////////////////////////////////////////////////////////////// // CServerInfoSet IMPLEMENT_DYNAMIC(CServerInfoSet, CRecordset) CServerInfoSet::CServerInfoSet(CDatabase* pdb) : CRecordset(pdb) { //{{AFX_FIELD_INIT(CServerInfoSet) m_ServerName = _T(""); m_ServerPrice = 0.0f; m_nFields = 2; //}}AFX_FIELD_INIT m_nDefaultType = snapshot; } CString CServerInfoSet::GetDefaultConnect() { return _T("ODBC;DSN=酒店管理系统"); } CString CServerInfoSet::GetDefaultSQL() { return _T("[ServerInfo]"); } void CServerInfoSet::DoFieldExchange(CFieldExchange* pFX) { //{{AFX_FIELD_MAP(CServerInfoSet) pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Text(pFX, _T("[ServerName]"), m_ServerName); RFX_Single(pFX, _T("[ServerPrice]"), m_ServerPrice); //}}AFX_FIELD_MAP } ///////////////////////////////////////////////////////////////////////////// // CServerInfoSet diagnostics #ifdef _DEBUG void CServerInfoSet::AssertValid() const { CRecordset::AssertValid(); } void CServerInfoSet::Dump(CDumpContext& dc) const { CRecordset::Dump(dc); } #endif //_DEBUG ///////////////////////////////////////////////////////////////////////////// // CFoodInfoSet IMPLEMENT_DYNAMIC(CFoodInfoSet, CRecordset) CFoodInfoSet::CFoodInfoSet(CDatabase* pdb) : CRecordset(pdb) { //{{AFX_FIELD_INIT(CFoodInfoSet) m_FoodName = _T(""); m_FoodPrice = 0.0f; m_nFields = 2; //}}AFX_FIELD_INIT m_nDefaultType = snapshot; } CString CFoodInfoSet::GetDefaultConnect() { return _T("ODBC;DSN=酒店管理系统"); } CString CFoodInfoSet::GetDefaultSQL() { return _T("[FoodInfo]"); } void CFoodInfoSet::DoFieldExchange(CFieldExchange* pFX) { //{{AFX_FIELD_MAP(CFoodInfoSet) pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Text(pFX, _T("[FoodName]"), m_FoodName); RFX_Single(pFX, _T("[FoodPrice]"), m_FoodPrice); //}}AFX_FIELD_MAP } ///////////////////////////////////////////////////////////////////////////// // CFoodInfoSet diagnostics #ifdef _DEBUG void CFoodInfoSet::AssertValid() const { CRecordset::AssertValid(); } void CFoodInfoSet::Dump(CDumpContext& dc) const { CRecordset::Dump(dc); } #endif //_DEBUG ///////////////////////////////////////////////////////////////////////////// // CEmployerInfoSet IMPLEMENT_DYNAMIC(CEmployerInfoSet, CRecordset) CEmployerInfoSet::CEmployerInfoSet(CDatabase* pdb) : CRecordset(pdb) { //{{AFX_FIELD_INIT(CEmployerInfoSet) m_EmployerCode = _T(""); m_Name = _T(""); m_Depart = _T(""); m_nFields = 3; //}}AFX_FIELD_INIT m_nDefaultType = snapshot; } CString CEmployerInfoSet::GetDefaultConnect() { return _T("ODBC;DSN=酒店管理系统"); } CString CEmployerInfoSet::GetDefaultSQL() { return _T("[EmployerInfo]"); } void CEmployerInfoSet::DoFieldExchange(CFieldExchange* pFX) { //{{AFX_FIELD_MAP(CEmployerInfoSet) pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Text(pFX, _T("[EmployerCode]"), m_EmployerCode); RFX_Text(pFX, _T("[Name]"), m_Name); RFX_Text(pFX, _T("[Depart]"), m_Depart); //}}AFX_FIELD_MAP } ///////////////////////////////////////////////////////////////////////////// // CEmployerInfoSet diagnostics #ifdef _DEBUG void CEmployerInfoSet::AssertValid() const { CRecordset::AssertValid(); } void CEmployerInfoSet::Dump(CDumpContext& dc) const { CRecordset::Dump(dc); } #endif //_DEBUG ///////////////////////////////////////////////////////////////////////////// // CBillContentInfoSet IMPLEMENT_DYNAMIC(CBillContentInfoSet, CRecordset) CBillContentInfoSet::CBillContentInfoSet(CDatabase* pdb) : CRecordset(pdb) { //{{AFX_FIELD_INIT(CBillContentInfoSet) m_BillCode = _T(""); m_BillContent = _T(""); m_nFields = 2; //}}AFX_FIELD_INIT m_nDefaultType = snapshot; } CString CBillContentInfoSet::GetDefaultConnect() { return _T("ODBC;DSN=酒店管理系统"); } CString CBillContentInfoSet::GetDefaultSQL() { return _T("[BillContentInfo]"); } void CBillContentInfoSet::DoFieldExchange(CFieldExchange* pFX) { //{{AFX_FIELD_MAP(CBillContentInfoSet) pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Text(pFX, _T("[BillCode]"), m_BillCode); RFX_Text(pFX, _T("[BillContent]"), m_BillContent); //}}AFX_FIELD_MAP } ///////////////////////////////////////////////////////////////////////////// // CBillContentInfoSet diagnostics #ifdef _DEBUG void CBillContentInfoSet::AssertValid() const { CRecordset::AssertValid(); } void CBillContentInfoSet::Dump(CDumpContext& dc) const { CRecordset::Dump(dc); } #endif //_DEBUG ///////////////////////////////////////////////////////////////////////////// // CBillCheckoutInfoSet IMPLEMENT_DYNAMIC(CBillCheckoutInfoSet, CRecordset) CBillCheckoutInfoSet::CBillCheckoutInfoSet(CDatabase* pdb) : CRecordset(pdb) { //{{AFX_FIELD_INIT(CBillCheckoutInfoSet) m_BillCode = _T(""); m_HandCode = _T(""); m_Sum = _T(""); m_nFields = 5; //}}AFX_FIELD_INIT m_nDefaultType = snapshot; } CString CBillCheckoutInfoSet::GetDefaultConnect() { return _T("ODBC;DSN=酒店管理系统"); } CString CBillCheckoutInfoSet::GetDefaultSQL() { return _T("[BillCheckoutInfo]"); } void CBillCheckoutInfoSet::DoFieldExchange(CFieldExchange* pFX) { //{{AFX_FIELD_MAP(CBillCheckoutInfoSet) pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Text(pFX, _T("[BillCode]"), m_BillCode); RFX_Text(pFX, _T("[HandCode]"), m_HandCode); RFX_Date(pFX, _T("[StartTime]"), m_StartTime); RFX_Date(pFX, _T("[EndTime]"), m_EndTime); RFX_Text(pFX, _T("[Sum]"), m_Sum); //}}AFX_FIELD_MAP } ///////////////////////////////////////////////////////////////////////////// // CBillCheckoutInfoSet diagnostics #ifdef _DEBUG void CBillCheckoutInfoSet::AssertValid() const { CRecordset::AssertValid(); } void CBillCheckoutInfoSet::Dump(CDumpContext& dc) const { CRecordset::Dump(dc); } #endif //_DEBUG ///////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////// // CDestineRoomSet IMPLEMENT_DYNAMIC(CDestineRoomSet, CRecordset) CDestineRoomSet::CDestineRoomSet(CDatabase* pdb) : CRecordset(pdb) { //{{AFX_FIELD_INIT(CDestineRoomSet) m_BillCode = _T(""); m_Certificate = _T(""); m_CeritifyCode = _T(""); m_DestinerName = _T(""); m_DestinerSex = _T(""); m_DestineMoney = _T(""); m_DestineTime = _T(""); m_DestineEndTime = _T(""); m_DestineRoomCode = _T(""); m_nFields = 9; //}}AFX_FIELD_INIT m_nDefaultType = snapshot; } CString CDestineRoomSet::GetDefaultConnect() { return _T("ODBC;DSN=酒店管理系统"); } CString CDestineRoomSet::GetDefaultSQL() { return _T("[RoomDestine]"); } void CDestineRoomSet::DoFieldExchange(CFieldExchange* pFX) { //{{AFX_FIELD_MAP(CDestineRoomSet) pFX->SetFieldType(CFieldExchange::outputColumn); RFX_Text(pFX, _T("[BillCode]"), m_BillCode); RFX_Text(pFX, _T("[Certificate]"), m_Certificate); RFX_Text(pFX, _T("[CeritifyCode]"), m_CeritifyCode); RFX_Text(pFX, _T("[DestinerName]"), m_DestinerName); RFX_Text(pFX, _T("[DestinerSex]"), m_DestinerSex); RFX_Text(pFX, _T("[DestineMoney]"), m_DestineMoney); RFX_Text(pFX, _T("[DestineTime]"), m_DestineTime); RFX_Text(pFX, _T("[DestineEndTime]"), m_DestineEndTime); RFX_Text(pFX, _T("[DestineRoomCode]"), m_DestineRoomCode); //}}AFX_FIELD_MAP } ///////////////////////////////////////////////////////////////////////////// // CDestineRoomSet diagnostics #ifdef _DEBUG void CDestineRoomSet::AssertValid() const { CRecordset::AssertValid(); } void CDestineRoomSet::Dump(CDumpContext& dc) const { CRecordset::Dump(dc); } #endif //_DEBUG